﻿CREATE PROCEDURE [dbo].[proc_Company_Getlist_User]
	(
		@UserName nvarchar(50)
	)
AS
begin
	Declare @CompanyId int
	EXEC @CompanyId=proc_Company_GetID @UserName,@CompanyId
	if @CompanyId=6
	Set @CompanyId=0
	Select
	Id,
	CompanyName From Company Where (Id=@CompanyId Or @CompanyId=0)
end
	RETURN
